** Import the data for the EV-charging stations and create variables that can be used to calculate the distance of every HH to the closest charging station. 


clear
import excel "$root/Data/Original/EV_Ladestation1.xlsx", first sheet("Tabelle1")
keep lat lon ns1name3
rename ns1name3 location

tempfile EV_charge1
save `EV_charge1'

clear
import excel "$root/Data/Original/EV_Ladestation2.xlsx", first sheet("Tabelle1")
keep lat lon ns1name3
rename ns1name3 location

append using `EV_charge1'
rename lat g_lat 
rename lon g_lon
do "$root/Code/Preparation/Management/WGS84toCH1903.do"
keep location GKODX GKODY

*only keep observations that are in or close around the canton of Berne
drop if GKODX<550000 | GKODX>675000
drop if GKODY<130000 | GKODY>250000

gen obs=_n

save "$root/Data/Original/EV_charge.dta", replace
